/*******************************************************************************************************

Table A2: Differences in Patronage across boroughs on Drummond's list

*******************************************************************************************************/

*Set directory path
cd "C:\Users\tsa23\Documents\petitions\replication files"

clear all

*read in our main dataset
use dta/did_rep.dta

drop if ID == 45 //University of Cambridge
drop if ID == 191 //University of Oxford

keep if sch_A==1 | sch_B == 1 | drummond!=. // the 120 on Drummond list are either coded 1 (selected) or 0 (not selected but at risk).

sort schedule /*schedule = K for the constituencies which keep their pre-reform seats.*/
*Wade (1831) data are entered directly from the source.
by schedule: tabulate rottenindex_pre  if year == 1830
by schedule: tabulate contested_elections_20_30 if year == 1830
